﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace Syx.Webapi.AppCode.Entities {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "JK_PACS", DisableSyncStructure = true)]
	public partial class JKPACS {

		[JsonProperty, Column(Name = "TAB_ID", DbType = "NUMBER(22)", IsPrimary = true)]
		public decimal TABID { get; set; }

		[JsonProperty, Column(Name = "AGE_TYPE", DbType = "VARCHAR2(10 BYTE)")]
		public string AGETYPE { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(30 BYTE)")]
		public string DEPARTMENT { get; set; }

		[JsonProperty, Column(Name = "DIAG_DESCRIB", DbType = "CLOB")]
		public string DIAGDESCRIB { get; set; }

		[JsonProperty, Column(Name = "DIAG_NAME", DbType = "VARCHAR2(1000 BYTE)")]
		public string DIAGNAME { get; set; }

		[JsonProperty, Column(Name = "EXAM_METHOD", DbType = "VARCHAR2(500 BYTE)")]
		public string EXAMMETHOD { get; set; }

		[JsonProperty, Column(Name = "EXAM_NAME", DbType = "VARCHAR2(500 BYTE)")]
		public string EXAMNAME { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(10 BYTE)")]
		public string EXAMTYPE { get; set; }

		[JsonProperty, Column(Name = "FLAG_AUTO", DbType = "VARCHAR2(100 BYTE)")]
		public string FLAGAUTO { get; set; }

		[JsonProperty, Column(Name = "FLAG_CUST", DbType = "VARCHAR2(50 BYTE)")]
		public string FLAGCUST { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(30 BYTE)")]
		public string INHOSPITALNO { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(30 BYTE)")]
		public string MENZHENNO { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(10 BYTE)")]
		public string MODALITY { get; set; }

		[JsonProperty, Column(Name = "PATIENT_ID", DbType = "VARCHAR2(50 BYTE)")]
		public string PATIENTID { get; set; }

		[JsonProperty, Column(Name = "PATIENT_NAME", DbType = "VARCHAR2(50 BYTE)")]
		public string PATIENTNAME { get; set; }

		[JsonProperty, Column(Name = "PATIENT_NO", DbType = "VARCHAR2(30 BYTE)")]
		public string PATIENTNO { get; set; }

		[JsonProperty, Column(DbType = "CLOB")]
		public string REFID { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? REGDATE { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? REGTIME { get; set; }

		[JsonProperty, Column(DbType = "CLOB")]
		public string RELID { get; set; }

		[JsonProperty, Column(Name = "REPORT_DATE", DbType = "DATE(7)")]
		public DateTime? REPORTDATE { get; set; }

		[JsonProperty, Column(Name = "REPORT_ID")]
		public int? REPORTID { get; set; }

		[JsonProperty, Column(Name = "SCAN_PART", DbType = "VARCHAR2(60 BYTE)")]
		public string SCANPART { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(10 BYTE)")]
		public string SEX { get; set; }

		[JsonProperty, Column(Name = "STUDY_AGE", DbType = "VARCHAR2(50 BYTE)")]
		public string STUDYAGE { get; set; }

		[JsonProperty, Column(Name = "STUDY_FLOWID")]
		public int? STUDYFLOWID { get; set; }

		[JsonProperty, Column(Name = "STUDY_ID")]
		public int? STUDYID { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? STUDYDATE { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? STUDYTIME { get; set; }

		[JsonProperty, Column(Name = "VISIT_ID", DbType = "VARCHAR2(10 BYTE)")]
		public string VISITID { get; set; }

		[JsonProperty, Column(Name = "YG_YSBL_PACS", DbType = "VARCHAR2(200 BYTE)")]
		public string YGYSBLPACS { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string ZYID { get; set; }

	}

}
